\hypertarget{db_install_sandbox_8php}{
\section{\-C\-:/\-Users/\-Jon/\-Downloads/\-O\-O\-P/db-\/control/inc/db\-Install\-Sandbox.php \-File \-Reference}
\label{db_install_sandbox_8php}\index{\-C\-:/\-Users/\-Jon/\-Downloads/\-O\-O\-P/db-\/control/inc/db\-Install\-Sandbox.\-php@{\-C\-:/\-Users/\-Jon/\-Downloads/\-O\-O\-P/db-\/control/inc/db\-Install\-Sandbox.\-php}}
}
\subsection*{\-Functions}
\begin{DoxyCompactItemize}
\item 
\hyperlink{db_install_sandbox_8php_ad426b65104577e2839255f998dcb11f2}{populate\-Database} ()
\item 
\hyperlink{db_install_sandbox_8php_ac532770113bad6a0d344a240b5dfcfec}{insert\-Organization\-Data} (\$name, \$description, \$address, \$address1, \$city, \$state, \$zip, \&\$id)
\item 
\hyperlink{db_install_sandbox_8php_a85b56bb0a6e1d82257b2b9b9b82387c4}{verify\-Inserted\-Organization} (\$id)
\item 
\hyperlink{db_install_sandbox_8php_a6690b1924436781ea9fc2e7d9b7a4fad}{insert\-Student\-Data} (\$fname, \$lname, \$username, \$current\-G\-P\-A, \$major, \$year\-Status, \$graduation\-Year, \$got\-Hired, \&\$id)
\item 
\hyperlink{db_install_sandbox_8php_a8094a4135599908646acd26c11023d38}{verify\-Inserted\-Student} (\$id)
\item 
\hyperlink{db_install_sandbox_8php_a0d45c51f893bf0e46bb0fc2293c1862a}{insert\-Contact\-Data} (\$organization\-I\-D, \$fname, \$lname, \$email, \$phone, \$ext, \$fax, \&\$id)
\item 
\hyperlink{db_install_sandbox_8php_ace3a98c17bf5546cf0e1efec565c0c21}{verify\-Inserted\-Contact} (\$id)
\item 
\hyperlink{db_install_sandbox_8php_ad5cb73c522c1cfa2c770698444faa622}{insert\-Category\-Data} (\$category\-Name, \&\$id)
\item 
\hyperlink{db_install_sandbox_8php_a6775c74276c3238a5855eed71b77d5cc}{verify\-Inserted\-Category} (\$id)
\item 
\hyperlink{db_install_sandbox_8php_a3f38aa81af7105d88300cd45b33c4e37}{insert\-Opportunity\-Data} (\$organization\-I\-D, \$contact\-I\-D, \$title, \$num\-Positions\-Available, \$semester, \$pay\-Rate, \$duration, \$responsibilities, \$qualifications, \$instructions, \$comments, \$categories, \$pending, \$date\-Added, \&\$id)
\item 
\hyperlink{db_install_sandbox_8php_adcd6300105e6916c20b0ee323663ca4d}{verify\-Inserted\-Opportunity} (\$id)
\item 
\hyperlink{db_install_sandbox_8php_aaa1bd797b2bbf1d78f273a6564eef022}{insert\-Internship\-Data} (\$opportunity\-I\-D, \$student\-I\-D, \$hours, \$special, \$semester, \&\$id)
\item 
\hyperlink{db_install_sandbox_8php_aad137d4913b1f261197d5384191119b1}{verify\-Inserted\-Internship} (\$id)
\item 
\hyperlink{db_install_sandbox_8php_a8f9c9f66a51056c5f49ee886ea67ef43}{insert\-User\-Data} (\$username, \$password, \$fname, \$lname, \$permission\-Level, \&\$id)
\item 
\hyperlink{db_install_sandbox_8php_ac0c8b6f76abda9123e486aa9a5372c0a}{verify\-Inserted\-User} (\$id)
\end{DoxyCompactItemize}


\subsection{\-Function \-Documentation}
\hypertarget{db_install_sandbox_8php_ad5cb73c522c1cfa2c770698444faa622}{
\index{db\-Install\-Sandbox.\-php@{db\-Install\-Sandbox.\-php}!insert\-Category\-Data@{insert\-Category\-Data}}
\index{insert\-Category\-Data@{insert\-Category\-Data}!dbInstallSandbox.php@{db\-Install\-Sandbox.\-php}}
\subsubsection[{insert\-Category\-Data}]{\setlength{\rightskip}{0pt plus 5cm}insert\-Category\-Data (
\begin{DoxyParamCaption}
\item[{\$}]{category\-Name, }
\item[{\&\$}]{id}
\end{DoxyParamCaption}
)}}
\label{db_install_sandbox_8php_ad5cb73c522c1cfa2c770698444faa622}


\-Definition at line 418 of file db\-Install\-Sandbox.\-php.

\hypertarget{db_install_sandbox_8php_a0d45c51f893bf0e46bb0fc2293c1862a}{
\index{db\-Install\-Sandbox.\-php@{db\-Install\-Sandbox.\-php}!insert\-Contact\-Data@{insert\-Contact\-Data}}
\index{insert\-Contact\-Data@{insert\-Contact\-Data}!dbInstallSandbox.php@{db\-Install\-Sandbox.\-php}}
\subsubsection[{insert\-Contact\-Data}]{\setlength{\rightskip}{0pt plus 5cm}insert\-Contact\-Data (
\begin{DoxyParamCaption}
\item[{\$}]{organization\-I\-D, }
\item[{\$}]{fname, }
\item[{\$}]{lname, }
\item[{\$}]{email, }
\item[{\$}]{phone, }
\item[{\$}]{ext, }
\item[{\$}]{fax, }
\item[{\&\$}]{id}
\end{DoxyParamCaption}
)}}
\label{db_install_sandbox_8php_a0d45c51f893bf0e46bb0fc2293c1862a}


\-Definition at line 393 of file db\-Install\-Sandbox.\-php.

\hypertarget{db_install_sandbox_8php_aaa1bd797b2bbf1d78f273a6564eef022}{
\index{db\-Install\-Sandbox.\-php@{db\-Install\-Sandbox.\-php}!insert\-Internship\-Data@{insert\-Internship\-Data}}
\index{insert\-Internship\-Data@{insert\-Internship\-Data}!dbInstallSandbox.php@{db\-Install\-Sandbox.\-php}}
\subsubsection[{insert\-Internship\-Data}]{\setlength{\rightskip}{0pt plus 5cm}insert\-Internship\-Data (
\begin{DoxyParamCaption}
\item[{\$}]{opportunity\-I\-D, }
\item[{\$}]{student\-I\-D, }
\item[{\$}]{hours, }
\item[{\$}]{special, }
\item[{\$}]{semester, }
\item[{\&\$}]{id}
\end{DoxyParamCaption}
)}}
\label{db_install_sandbox_8php_aaa1bd797b2bbf1d78f273a6564eef022}


\-Definition at line 474 of file db\-Install\-Sandbox.\-php.

\hypertarget{db_install_sandbox_8php_a3f38aa81af7105d88300cd45b33c4e37}{
\index{db\-Install\-Sandbox.\-php@{db\-Install\-Sandbox.\-php}!insert\-Opportunity\-Data@{insert\-Opportunity\-Data}}
\index{insert\-Opportunity\-Data@{insert\-Opportunity\-Data}!dbInstallSandbox.php@{db\-Install\-Sandbox.\-php}}
\subsubsection[{insert\-Opportunity\-Data}]{\setlength{\rightskip}{0pt plus 5cm}insert\-Opportunity\-Data (
\begin{DoxyParamCaption}
\item[{\$}]{organization\-I\-D, }
\item[{\$}]{contact\-I\-D, }
\item[{\$}]{title, }
\item[{\$}]{num\-Positions\-Available, }
\item[{\$}]{semester, }
\item[{\$}]{pay\-Rate, }
\item[{\$}]{duration, }
\item[{\$}]{responsibilities, }
\item[{\$}]{qualifications, }
\item[{\$}]{instructions, }
\item[{\$}]{comments, }
\item[{\$}]{categories, }
\item[{\$}]{pending, }
\item[{\$}]{date\-Added, }
\item[{\&\$}]{id}
\end{DoxyParamCaption}
)}}
\label{db_install_sandbox_8php_a3f38aa81af7105d88300cd45b33c4e37}


\-Definition at line 440 of file db\-Install\-Sandbox.\-php.

\hypertarget{db_install_sandbox_8php_ac532770113bad6a0d344a240b5dfcfec}{
\index{db\-Install\-Sandbox.\-php@{db\-Install\-Sandbox.\-php}!insert\-Organization\-Data@{insert\-Organization\-Data}}
\index{insert\-Organization\-Data@{insert\-Organization\-Data}!dbInstallSandbox.php@{db\-Install\-Sandbox.\-php}}
\subsubsection[{insert\-Organization\-Data}]{\setlength{\rightskip}{0pt plus 5cm}insert\-Organization\-Data (
\begin{DoxyParamCaption}
\item[{\$}]{name, }
\item[{\$}]{description, }
\item[{\$}]{address, }
\item[{\$}]{address1, }
\item[{\$}]{city, }
\item[{\$}]{state, }
\item[{\$}]{zip, }
\item[{\&\$}]{id}
\end{DoxyParamCaption}
)}}
\label{db_install_sandbox_8php_ac532770113bad6a0d344a240b5dfcfec}


\-Definition at line 336 of file db\-Install\-Sandbox.\-php.

\hypertarget{db_install_sandbox_8php_a6690b1924436781ea9fc2e7d9b7a4fad}{
\index{db\-Install\-Sandbox.\-php@{db\-Install\-Sandbox.\-php}!insert\-Student\-Data@{insert\-Student\-Data}}
\index{insert\-Student\-Data@{insert\-Student\-Data}!dbInstallSandbox.php@{db\-Install\-Sandbox.\-php}}
\subsubsection[{insert\-Student\-Data}]{\setlength{\rightskip}{0pt plus 5cm}insert\-Student\-Data (
\begin{DoxyParamCaption}
\item[{\$}]{fname, }
\item[{\$}]{lname, }
\item[{\$}]{username, }
\item[{\$}]{current\-G\-P\-A, }
\item[{\$}]{major, }
\item[{\$}]{year\-Status, }
\item[{\$}]{graduation\-Year, }
\item[{\$}]{got\-Hired, }
\item[{\&\$}]{id}
\end{DoxyParamCaption}
)}}
\label{db_install_sandbox_8php_a6690b1924436781ea9fc2e7d9b7a4fad}


\-Definition at line 367 of file db\-Install\-Sandbox.\-php.

\hypertarget{db_install_sandbox_8php_a8f9c9f66a51056c5f49ee886ea67ef43}{
\index{db\-Install\-Sandbox.\-php@{db\-Install\-Sandbox.\-php}!insert\-User\-Data@{insert\-User\-Data}}
\index{insert\-User\-Data@{insert\-User\-Data}!dbInstallSandbox.php@{db\-Install\-Sandbox.\-php}}
\subsubsection[{insert\-User\-Data}]{\setlength{\rightskip}{0pt plus 5cm}insert\-User\-Data (
\begin{DoxyParamCaption}
\item[{\$}]{username, }
\item[{\$}]{password, }
\item[{\$}]{fname, }
\item[{\$}]{lname, }
\item[{\$}]{permission\-Level, }
\item[{\&\$}]{id}
\end{DoxyParamCaption}
)}}
\label{db_install_sandbox_8php_a8f9c9f66a51056c5f49ee886ea67ef43}


\-Definition at line 500 of file db\-Install\-Sandbox.\-php.

\hypertarget{db_install_sandbox_8php_ad426b65104577e2839255f998dcb11f2}{
\index{db\-Install\-Sandbox.\-php@{db\-Install\-Sandbox.\-php}!populate\-Database@{populate\-Database}}
\index{populate\-Database@{populate\-Database}!dbInstallSandbox.php@{db\-Install\-Sandbox.\-php}}
\subsubsection[{populate\-Database}]{\setlength{\rightskip}{0pt plus 5cm}populate\-Database (
\begin{DoxyParamCaption}
{}
\end{DoxyParamCaption}
)}}
\label{db_install_sandbox_8php_ad426b65104577e2839255f998dcb11f2}
\-Populates the database with sample data. \-Makes calls to insert\-X\-X\-X\-Data() functions in this file, where \-X\-X\-X corresponds to a table in the database. \-Each of these calls takes as arguments the data that's inserted. 

\-Definition at line 44 of file db\-Install\-Sandbox.\-php.

\hypertarget{db_install_sandbox_8php_a6775c74276c3238a5855eed71b77d5cc}{
\index{db\-Install\-Sandbox.\-php@{db\-Install\-Sandbox.\-php}!verify\-Inserted\-Category@{verify\-Inserted\-Category}}
\index{verify\-Inserted\-Category@{verify\-Inserted\-Category}!dbInstallSandbox.php@{db\-Install\-Sandbox.\-php}}
\subsubsection[{verify\-Inserted\-Category}]{\setlength{\rightskip}{0pt plus 5cm}verify\-Inserted\-Category (
\begin{DoxyParamCaption}
\item[{\$}]{id}
\end{DoxyParamCaption}
)}}
\label{db_install_sandbox_8php_a6775c74276c3238a5855eed71b77d5cc}


\-Definition at line 427 of file db\-Install\-Sandbox.\-php.

\hypertarget{db_install_sandbox_8php_ace3a98c17bf5546cf0e1efec565c0c21}{
\index{db\-Install\-Sandbox.\-php@{db\-Install\-Sandbox.\-php}!verify\-Inserted\-Contact@{verify\-Inserted\-Contact}}
\index{verify\-Inserted\-Contact@{verify\-Inserted\-Contact}!dbInstallSandbox.php@{db\-Install\-Sandbox.\-php}}
\subsubsection[{verify\-Inserted\-Contact}]{\setlength{\rightskip}{0pt plus 5cm}verify\-Inserted\-Contact (
\begin{DoxyParamCaption}
\item[{\$}]{id}
\end{DoxyParamCaption}
)}}
\label{db_install_sandbox_8php_ace3a98c17bf5546cf0e1efec565c0c21}


\-Definition at line 404 of file db\-Install\-Sandbox.\-php.

\hypertarget{db_install_sandbox_8php_aad137d4913b1f261197d5384191119b1}{
\index{db\-Install\-Sandbox.\-php@{db\-Install\-Sandbox.\-php}!verify\-Inserted\-Internship@{verify\-Inserted\-Internship}}
\index{verify\-Inserted\-Internship@{verify\-Inserted\-Internship}!dbInstallSandbox.php@{db\-Install\-Sandbox.\-php}}
\subsubsection[{verify\-Inserted\-Internship}]{\setlength{\rightskip}{0pt plus 5cm}verify\-Inserted\-Internship (
\begin{DoxyParamCaption}
\item[{\$}]{id}
\end{DoxyParamCaption}
)}}
\label{db_install_sandbox_8php_aad137d4913b1f261197d5384191119b1}


\-Definition at line 485 of file db\-Install\-Sandbox.\-php.

\hypertarget{db_install_sandbox_8php_adcd6300105e6916c20b0ee323663ca4d}{
\index{db\-Install\-Sandbox.\-php@{db\-Install\-Sandbox.\-php}!verify\-Inserted\-Opportunity@{verify\-Inserted\-Opportunity}}
\index{verify\-Inserted\-Opportunity@{verify\-Inserted\-Opportunity}!dbInstallSandbox.php@{db\-Install\-Sandbox.\-php}}
\subsubsection[{verify\-Inserted\-Opportunity}]{\setlength{\rightskip}{0pt plus 5cm}verify\-Inserted\-Opportunity (
\begin{DoxyParamCaption}
\item[{\$}]{id}
\end{DoxyParamCaption}
)}}
\label{db_install_sandbox_8php_adcd6300105e6916c20b0ee323663ca4d}


\-Definition at line 457 of file db\-Install\-Sandbox.\-php.

\hypertarget{db_install_sandbox_8php_a85b56bb0a6e1d82257b2b9b9b82387c4}{
\index{db\-Install\-Sandbox.\-php@{db\-Install\-Sandbox.\-php}!verify\-Inserted\-Organization@{verify\-Inserted\-Organization}}
\index{verify\-Inserted\-Organization@{verify\-Inserted\-Organization}!dbInstallSandbox.php@{db\-Install\-Sandbox.\-php}}
\subsubsection[{verify\-Inserted\-Organization}]{\setlength{\rightskip}{0pt plus 5cm}verify\-Inserted\-Organization (
\begin{DoxyParamCaption}
\item[{\$}]{id}
\end{DoxyParamCaption}
)}}
\label{db_install_sandbox_8php_a85b56bb0a6e1d82257b2b9b9b82387c4}
\-Outputs data that was inserted in the organization table by querying the table. \-Either an error message is printed out about none or multiple instances were found for the given primary key value; or the attribute values of the found instance are printed out 
\begin{DoxyParams}[1]{\-Parameters}
integer & {\em \$id} & \-The primary key value based on which the query is done. \\
\hline
\end{DoxyParams}


\-Definition at line 353 of file db\-Install\-Sandbox.\-php.

\hypertarget{db_install_sandbox_8php_a8094a4135599908646acd26c11023d38}{
\index{db\-Install\-Sandbox.\-php@{db\-Install\-Sandbox.\-php}!verify\-Inserted\-Student@{verify\-Inserted\-Student}}
\index{verify\-Inserted\-Student@{verify\-Inserted\-Student}!dbInstallSandbox.php@{db\-Install\-Sandbox.\-php}}
\subsubsection[{verify\-Inserted\-Student}]{\setlength{\rightskip}{0pt plus 5cm}verify\-Inserted\-Student (
\begin{DoxyParamCaption}
\item[{\$}]{id}
\end{DoxyParamCaption}
)}}
\label{db_install_sandbox_8php_a8094a4135599908646acd26c11023d38}


\-Definition at line 379 of file db\-Install\-Sandbox.\-php.

\hypertarget{db_install_sandbox_8php_ac0c8b6f76abda9123e486aa9a5372c0a}{
\index{db\-Install\-Sandbox.\-php@{db\-Install\-Sandbox.\-php}!verify\-Inserted\-User@{verify\-Inserted\-User}}
\index{verify\-Inserted\-User@{verify\-Inserted\-User}!dbInstallSandbox.php@{db\-Install\-Sandbox.\-php}}
\subsubsection[{verify\-Inserted\-User}]{\setlength{\rightskip}{0pt plus 5cm}verify\-Inserted\-User (
\begin{DoxyParamCaption}
\item[{\$}]{id}
\end{DoxyParamCaption}
)}}
\label{db_install_sandbox_8php_ac0c8b6f76abda9123e486aa9a5372c0a}


\-Definition at line 511 of file db\-Install\-Sandbox.\-php.

